object FaturaListesiF: TFaturaListesiF
  Left = 59
  Top = 79
  Width = 1077
  Height = 573
  Caption = #304'rsaliye Listesi'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  KeyPreview = True
  OldCreateOrder = False
  Position = poDefaultPosOnly
  Scaled = False
  OnClose = FormClose
  OnCreate = FormCreate
  OnKeyDown = FormKeyDown
  OnKeyPress = FormKeyPress
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object Panel2: TPanel
    Left = 0
    Top = 496
    Width = 1069
    Height = 50
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 0
    DesignSize = (
      1069
      50)
    object Label38: TLabel
      Left = 503
      Top = 31
      Width = 60
      Height = 14
      Caption = #304'rsaliye S'#305'n'#305'f'#305
      Transparent = True
    end
    object Label2: TLabel
      Left = 503
      Top = 9
      Width = 53
      Height = 14
      Caption = #304'rsaliye Tipi'
      Transparent = True
    end
    object bkapat: TBitBtn
      Left = 974
      Top = 10
      Width = 84
      Height = 34
      Anchors = [akRight, akBottom]
      Caption = 'Kapat'
      TabOrder = 0
      OnClick = bkapatClick
    end
    object tipik: TwwDBComboBox
      Left = 568
      Top = 4
      Width = 205
      Height = 22
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Sorted = False
      TabOrder = 1
      UnboundDataType = wwDefault
      OnCloseUp = tipikCloseUp
    end
    object belgeTuru: TwwDBComboBox
      Left = 568
      Top = 27
      Width = 205
      Height = 22
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Sorted = False
      TabOrder = 6
      UnboundDataType = wwDefault
      OnCloseUp = belgeTuruCloseUp
    end
    object GarantiGiris: TPanel
      Tag = 1017
      Left = 224
      Top = 8
      Width = 25
      Height = 17
      BevelOuter = bvNone
      TabOrder = 8
    end
    object GarantiCikis: TPanel
      Tag = 1018
      Left = 224
      Top = 26
      Width = 25
      Height = 17
      BevelOuter = bvNone
      TabOrder = 9
    end
    object SerinoGir: TPanel
      Tag = 1031
      Left = 272
      Top = 10
      Width = 13
      Height = 17
      BevelOuter = bvNone
      TabOrder = 10
    end
    object Serinogir3Gun: TPanel
      Tag = 1032
      Left = 272
      Top = 27
      Width = 25
      Height = 17
      BevelOuter = bvNone
      TabOrder = 11
    end
    object btSiparisFaturaKontrol: TButton
      Tag = 1033
      Left = 785
      Top = 68
      Width = 84
      Height = 34
      Caption = 'Fatura-Sipari'#351' Kontrol'
      TabOrder = 12
      Visible = False
      WordWrap = True
      OnClick = btSiparisFaturaKontrolClick
    end
    object pnlirsaliyeicerik: TPanel
      Tag = 1034
      Left = 270
      Top = -1
      Width = 25
      Height = 17
      BevelOuter = bvNone
      TabOrder = 13
      Visible = False
    end
    object barama: TBitBtn
      Left = 404
      Top = 10
      Width = 86
      Height = 28
      Caption = 'Ara - F3'
      TabOrder = 3
      OnClick = baramaClick
    end
    object blistele: TBitBtn
      Left = 307
      Top = 10
      Width = 90
      Height = 28
      Caption = 'Listele - F5'
      TabOrder = 5
      OnClick = blisteleClick
    end
    object byazdir: TBitBtn
      Left = 136
      Top = 10
      Width = 55
      Height = 28
      Caption = 'Export'
      TabOrder = 4
      OnClick = byazdirClick
    end
    object bincele: TBitBtn
      Left = 75
      Top = 10
      Width = 55
      Height = 28
      Caption = '&'#304'ncele'
      TabOrder = 2
      OnClick = binceleClick
    end
    object bduzelt: TBitBtn
      Tag = 1002
      Left = 14
      Top = 10
      Width = 55
      Height = 28
      Caption = '&D'#252'zelt'
      TabOrder = 7
      OnClick = binceleClick
    end
    object btUPSGecmisDataCek: TButton
      Left = 878
      Top = 63
      Width = 75
      Height = 34
      Caption = 'UPS Ge'#231'mi'#351' Data'
      TabOrder = 14
      Visible = False
      WordWrap = True
      OnClick = btUPSGecmisDataCekClick
    end
    object btFaturaAktar: TButton
      Left = 795
      Top = 14
      Width = 100
      Height = 25
      Caption = 'stok ata'
      TabOrder = 15
      Visible = False
      OnClick = btFaturaAktarClick
    end
  end
  object PageControl1: TPageControl
    Left = 0
    Top = 138
    Width = 1069
    Height = 358
    ActivePage = TS1
    Align = alClient
    TabOrder = 1
    object TS1: TTabSheet
      Caption = 'Liste'
      object cxgrid1: TcxGrid
        Left = 0
        Top = 0
        Width = 1061
        Height = 284
        Align = alClient
        PopupMenu = PopupMenu1
        TabOrder = 0
        LookAndFeel.NativeStyle = True
        object GrdFaturaListesi: TcxGridDBTableView
          OnDblClick = GrdFaturaListesiDblClick
          OnKeyPress = GrdFaturaListesiKeyPress
          NavigatorButtons.ConfirmDelete = False
          OnCellClick = GrdFaturaListesiCellClick
          OnCustomDrawCell = GrdFaturaListesiCustomDrawCell
          DataController.DataSource = FaturaQS
          DataController.Filter.Options = [fcoCaseInsensitive]
          DataController.Summary.DefaultGroupSummaryItems = <
            item
              Format = 'Adet : ###.###'
              Kind = skCount
              FieldName = 'bilisno'
            end>
          DataController.Summary.FooterSummaryItems = <>
          DataController.Summary.SummaryGroups = <>
          FilterRow.InfoText = ' '
          FilterRow.Visible = True
          FilterRow.ApplyChanges = fracImmediately
          OptionsBehavior.IncSearch = True
          OptionsData.CancelOnExit = False
          OptionsData.Deleting = False
          OptionsData.DeletingConfirmation = False
          OptionsData.Editing = False
          OptionsData.Inserting = False
          OptionsSelection.UnselectFocusedRecordOnExit = False
          OptionsView.Indicator = True
          Styles.ContentOdd = dm.cxStyle15
          Styles.StyleSheet = dm.tvssDevExpress
          OnColumnHeaderClick = GrdFaturaListesiColumnHeaderClick
          object GrdFaturaListesiiptal: TcxGridDBColumn
            Caption = #304'pt.'
            DataBinding.FieldName = 'iptal'
            Width = 31
          end
          object GrdFaturaListesidurum: TcxGridDBColumn
            Caption = 'Sip. Durumu'
            DataBinding.FieldName = 'durum'
            PropertiesClassName = 'TcxImageComboBoxProperties'
            Properties.Alignment.Horz = taLeftJustify
            Properties.Items = <
              item
                Description = #304#351'lem Yap'#305'lmad'#305
                Value = '1'
              end
              item
                Description = 'Devam Ediyor'
                Value = '2'
              end
              item
                Description = 'Tamamland'#305
                Value = '3'
              end
              item
                Description = 'G'#246'nderildi'
                Value = '4'
              end>
            Width = 56
          end
          object GrdFaturaListesiBilisNo: TcxGridDBColumn
            Caption = 'Bili'#351'.No'
            DataBinding.FieldName = 'bilisno'
            Width = 56
          end
          object GrdFaturaListesiBelgeNo: TcxGridDBColumn
            Caption = 'Sipari'#351' No'
            DataBinding.FieldName = 'belgeno'
            SortIndex = 0
            SortOrder = soAscending
            Width = 70
          end
          object GrdFaturaListesitarih: TcxGridDBColumn
            Caption = 'Tarih'
            DataBinding.FieldName = 'tarih'
            Width = 76
          end
          object GrdFaturaListesiunityirsaliyeno: TcxGridDBColumn
            Caption = #304'rsaliye No'
            DataBinding.FieldName = 'unityirsaliyeno'
            Width = 73
          end
          object GrdFaturaListesifirmaadi: TcxGridDBColumn
            Caption = 'Firma Ad'#305
            DataBinding.FieldName = 'firmaadi'
            Width = 186
          end
          object GrdFaturaListesiSevkKodu: TcxGridDBColumn
            Caption = 'Sevkiyat Kodu'
            DataBinding.FieldName = 'SevkKodu'
            Width = 71
          end
          object GrdFaturaListesiSevkAciklama: TcxGridDBColumn
            Caption = 'Sevkiyat Ad'#305
            DataBinding.FieldName = 'SevkAciklama'
            Width = 113
          end
          object GrdFaturaListesiHar_durumu: TcxGridDBColumn
            Caption = 'Tes. Durumu'
            DataBinding.FieldName = 'Har_Durumux'
            Width = 66
          end
          object GrdFaturaListesiKoli: TcxGridDBColumn
            Caption = 'Ba'#287
            DataBinding.FieldName = 'OkutmaKoli'
            Width = 43
          end
          object GrdFaturaListesiBag: TcxGridDBColumn
            Caption = 'Koli'
            DataBinding.FieldName = 'Bag'
            Width = 38
          end
          object GrdFaturaListesiFirmaKodu: TcxGridDBColumn
            DataBinding.FieldName = 'FirmaKodu'
            Width = 136
          end
          object GrdFaturaListesiEmirNo: TcxGridDBColumn
            Caption = 'Emir No'
            DataBinding.FieldName = 'EmirNo'
            Width = 54
          end
          object GrdFaturaListesiOzelKod: TcxGridDBColumn
            Caption = #214'zelKod'
            DataBinding.FieldName = 'cozelkod'
          end
          object GrdFaturaListesiOzelKod2: TcxGridDBColumn
            Caption = #214'zelKod2'
            DataBinding.FieldName = 'cOzelKod2'
          end
          object GrdFaturaListesiOzelKod5: TcxGridDBColumn
            Caption = #214'zelKod5'
            DataBinding.FieldName = 'cozelkod5'
          end
          object GrdFaturaListesiUretimDurum: TcxGridDBColumn
            Caption = #220'retim Durum'
            DataBinding.FieldName = 'UretimDurum'
            Width = 75
          end
          object GrdFaturaListesiStokkodu: TcxGridDBColumn
            DataBinding.FieldName = 'Stokkodu'
            Width = 157
          end
          object GrdFaturaListesiCinsi: TcxGridDBColumn
            DataBinding.FieldName = 'Cinsi'
            Width = 136
          end
          object GrdFaturaListesiMiktar: TcxGridDBColumn
            DataBinding.FieldName = 'Miktar'
            Width = 52
          end
          object GrdFaturaListesiSerinos: TcxGridDBColumn
            Caption = 'Seri No'
            DataBinding.FieldName = 'serinos'
            Width = 112
          end
          object GrdFaturaListesiOkutulanMiktar: TcxGridDBColumn
            Caption = 'Okutulan Miktar'
            DataBinding.FieldName = 'OkutulanMiktar'
          end
          object GrdFaturaListesiAdres: TcxGridDBColumn
            DataBinding.FieldName = 'Adres'
          end
          object GrdFaturaListesiSiparisTarih: TcxGridDBColumn
            Caption = 'Sipari'#351' Tarihi'
            DataBinding.FieldName = 'SiparisTarih'
          end
          object GrdFaturaListesiGonderiNo: TcxGridDBColumn
            Caption = 'G'#246'nderi No'
            DataBinding.FieldName = 'GonderiNo'
          end
          object GrdFaturaListesiilce: TcxGridDBColumn
            Caption = #304'l'#231'e'
            DataBinding.FieldName = 'ilce'
          end
          object GrdFaturaListesiSehir: TcxGridDBColumn
            Caption = #350'ehir'
            DataBinding.FieldName = 'Sehir'
          end
          object GrdFaturaListesiSevkAdres: TcxGridDBColumn
            Caption = 'Sevk Adres'
            DataBinding.FieldName = 'SevkAdres'
          end
          object GrdFaturaListesiSevkilce: TcxGridDBColumn
            Caption = 'Sevk '#304'l'#231'e'
            DataBinding.FieldName = 'Sevkilce'
          end
          object GrdFaturaListesiSevkSehir: TcxGridDBColumn
            Caption = 'Sevk '#350'ehir'
            DataBinding.FieldName = 'SevkSehir'
          end
          object GrdFaturaListesiSiparisBelgeNo: TcxGridDBColumn
            Caption = 'Sipari'#351' BelgeNo'
            DataBinding.FieldName = 'SiparisBelgeNo'
          end
          object GrdFaturaListesiKargoFirma: TcxGridDBColumn
            Caption = 'Kargo Firma'
            DataBinding.FieldName = 'KargoFirma'
            Width = 72
          end
          object GrdFaturaListesiOdemeTipi: TcxGridDBColumn
            Caption = #214'deme Tipi'
            DataBinding.FieldName = 'OdemeTipi'
            PropertiesClassName = 'TcxImageComboBoxProperties'
            Properties.Items = <
              item
                Description = 'P/'#214
                ImageIndex = 0
                Value = 'P'#214
              end
              item
                Description = #220'/A'
                Value = #220'A'
              end>
          end
          object GrdFaturaListesiSonKontrolOKTarih: TcxGridDBColumn
            Caption = 'Son Kontrol Tarihi'
            DataBinding.FieldName = 'SonKontrolOKTarih'
            Width = 91
          end
          object GrdFaturaListesiSonKontrolOK: TcxGridDBColumn
            Caption = 'SK?'
            DataBinding.FieldName = 'SonKontrolOK'
            PropertiesClassName = 'TcxCheckBoxProperties'
            Properties.NullStyle = nssUnchecked
            Width = 41
          end
          object GrdFaturaListesiKargoFiyat: TcxGridDBColumn
            Caption = 'Kargo Fiyat'
            DataBinding.FieldName = 'KargoFiyat'
            Width = 50
          end
          object GrdFaturaListesiKargoDesi: TcxGridDBColumn
            DataBinding.FieldName = 'KargoDesi'
            Width = 50
          end
          object GrdFaturaListesiAltNusha: TcxGridDBColumn
            Caption = 'Alt N'#252'sha'
            DataBinding.FieldName = 'AltNusha'
            PropertiesClassName = 'TcxCheckBoxProperties'
            Properties.NullStyle = nssUnchecked
          end
          object GrdFaturaListesiUPSBARKODIRS: TcxGridDBColumn
            Caption = 'UPS BARKOD IRS'
            DataBinding.FieldName = 'UPSBARKODIRS'
          end
          object GrdFaturaListesiUPIRSNO: TcxGridDBColumn
            Caption = 'UPS IRSNO'
            DataBinding.FieldName = 'UPIRSNO'
          end
          object GrdFaturaListesiUPSAktarimDate: TcxGridDBColumn
            Caption = 'UPS Aktar'#305'm Date'
            DataBinding.FieldName = 'UPSAktarimDate'
          end
        end
        object cxgrid1Level1: TcxGridLevel
          GridView = GrdFaturaListesi
        end
      end
      object Panel4: TPanel
        Tag = 1037
        Left = 0
        Top = 284
        Width = 1061
        Height = 45
        Align = alBottom
        AutoSize = True
        BevelOuter = bvNone
        TabOrder = 1
        object grpFatura: TGroupBox
          Left = 0
          Top = 0
          Width = 1061
          Height = 45
          Align = alBottom
          Caption = '  Fatura Kargoya '#199'evir  '
          TabOrder = 0
          Visible = False
          OnDblClick = grpFaturaDblClick
          object Label5: TLabel
            Left = 12
            Top = 22
            Width = 36
            Height = 14
            Caption = #304'rs./Fat.'
          end
          object Label6: TLabel
            Left = 209
            Top = 19
            Width = 66
            Height = 14
            Caption = 'Kargo Firmas'#305
          end
          object Label7: TLabel
            Left = 411
            Top = 19
            Width = 53
            Height = 14
            Caption = #214'deme Tipi'
          end
          object edFatKargo: TEdit
            Left = 51
            Top = 17
            Width = 121
            Height = 22
            TabStop = False
            TabOrder = 0
            OnKeyPress = edFatKargoKeyPress
          end
          object Kargo: TwwDBLookupCombo
            Left = 281
            Top = 17
            Width = 95
            Height = 22
            DisableThemes = False
            DropDownAlignment = taLeftJustify
            Selected.Strings = (
              'Ad'#9'50'#9'Ad'#9#9)
            LookupTable = adoKargoTan
            LookupField = 'ID'
            Style = csDropDownList
            Navigator = False
            TabOrder = 1
            AutoDropDown = True
            ShowButton = True
            UseTFields = False
            AllowClearKey = False
          end
          object OdemeTipi: TwwDBComboBox
            Left = 473
            Top = 17
            Width = 53
            Height = 22
            ShowButton = False
            Style = csDropDownList
            MapList = True
            AllowClearKey = False
            Color = 14811135
            DataField = 'OdemeSekli'
            DataSource = dm.FaturaS
            DropDownCount = 8
            Font.Charset = TURKISH_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'Arial'
            Font.Style = []
            ItemHeight = 0
            Items.Strings = (
              'P/'#214#9'P'#214
              #220'/A'#9#220'A')
            ItemIndex = 1
            ParentFont = False
            ReadOnly = True
            Sorted = False
            TabOrder = 2
            UnboundDataType = wwDefault
            UsePictureMask = False
          end
        end
      end
    end
    object TS2: TTabSheet
      Caption = 'Pivot'
      ImageIndex = 1
      object PivotGrid1: TcxDBPivotGrid
        Left = 0
        Top = 30
        Width = 1061
        Height = 299
        Align = alClient
        Groups = <>
        TabOrder = 0
        object PivotGrid1iptal: TcxDBPivotGridField
          AreaIndex = 0
          DataBinding.FieldName = 'iptal'
          Visible = True
        end
        object PivotGrid1Durum: TcxDBPivotGridField
          AreaIndex = 3
          IsCaptionAssigned = True
          Caption = 'Sip.Durum'
          DataBinding.FieldName = 'Durum'
          Visible = True
        end
        object PivotGrid1bilisno: TcxDBPivotGridField
          AreaIndex = 8
          IsCaptionAssigned = True
          Caption = 'Bili'#351'No'
          DataBinding.FieldName = 'bilisno'
          Visible = True
        end
        object PivotGrid1belgeno: TcxDBPivotGridField
          AreaIndex = 10
          IsCaptionAssigned = True
          Caption = 'Sipari'#351' No'
          DataBinding.FieldName = 'belgeno'
          Visible = True
        end
        object PivotGrid1tarih: TcxDBPivotGridField
          AreaIndex = 9
          DataBinding.FieldName = 'tarih'
          Visible = True
        end
        object PivotGrid1unityirsaliyeno: TcxDBPivotGridField
          AreaIndex = 11
          DataBinding.FieldName = 'unityirsaliyeno'
          Visible = True
        end
        object PivotGrid1FirmaKodu: TcxDBPivotGridField
          Area = faRow
          AreaIndex = 0
          DataBinding.FieldName = 'FirmaKodu'
          Visible = True
        end
        object PivotGrid1firmaadi: TcxDBPivotGridField
          Area = faRow
          AreaIndex = 1
          IsCaptionAssigned = True
          Caption = 'Firma Ad'#305
          DataBinding.FieldName = 'firmaadi'
          Visible = True
        end
        object PivotGrid1COzelkod: TcxDBPivotGridField
          AreaIndex = 12
          IsCaptionAssigned = True
          Caption = #214'zelKod'
          DataBinding.FieldName = 'COzelkod'
          Visible = True
        end
        object PivotGrid1COzelkod2: TcxDBPivotGridField
          AreaIndex = 20
          IsCaptionAssigned = True
          Caption = #214'zelkod2'
          DataBinding.FieldName = 'COzelkod2'
          Visible = True
        end
        object PivotGrid1COzelkod5: TcxDBPivotGridField
          AreaIndex = 21
          IsCaptionAssigned = True
          Caption = #214'zelkod5'
          DataBinding.FieldName = 'COzelkod5'
          Visible = True
        end
        object PivotGrid1Har_Durumux: TcxDBPivotGridField
          AreaIndex = 4
          IsCaptionAssigned = True
          Caption = 'Tes.Durum'
          DataBinding.FieldName = 'Har_Durumux'
          Visible = True
        end
        object PivotGrid1SevkKodu: TcxDBPivotGridField
          AreaIndex = 1
          IsCaptionAssigned = True
          Caption = 'Sevkiyat Kodu'
          DataBinding.FieldName = 'SevkKodu'
          Visible = True
        end
        object PivotGrid1SevkAciklama: TcxDBPivotGridField
          AreaIndex = 2
          IsCaptionAssigned = True
          Caption = 'Sevkiyat Ad'#305
          DataBinding.FieldName = 'SevkAciklama'
          Visible = True
        end
        object PivotGrid1Stokkodu: TcxDBPivotGridField
          AreaIndex = 17
          DataBinding.FieldName = 'Stokkodu'
          Visible = True
        end
        object PivotGrid1Cinsi: TcxDBPivotGridField
          AreaIndex = 7
          DataBinding.FieldName = 'Cinsi'
          Visible = True
        end
        object PivotGrid1Miktar: TcxDBPivotGridField
          Area = faData
          AreaIndex = 0
          DataBinding.FieldName = 'Miktar'
          Visible = True
        end
        object PivotGrid1SeriNos: TcxDBPivotGridField
          AreaIndex = 5
          IsCaptionAssigned = True
          Caption = 'SeriNo'
          DataBinding.FieldName = 'SeriNos'
          Visible = True
        end
        object PivotGrid1MusteriFaturaTarihi: TcxDBPivotGridField
          AreaIndex = 6
          DataBinding.FieldName = 'MusteriFaturaTarihi'
          Visible = True
        end
        object PivotGrid1StokDurum: TcxDBPivotGridField
          AreaIndex = 16
          IsCaptionAssigned = True
          Caption = 'StokDurum'
          DataBinding.FieldName = 'StokDurum'
          Visible = True
        end
        object PivotGrid1Sehir: TcxDBPivotGridField
          AreaIndex = 19
          IsCaptionAssigned = True
          Caption = #350'ehir'
          DataBinding.FieldName = 'Sehir'
          Visible = True
        end
        object PivotGrid1GununTarihi: TcxDBPivotGridField
          AreaIndex = 13
          IsCaptionAssigned = True
          Caption = 'G'#252'n'#252'n Tarihi'
          DataBinding.FieldName = 'GununTarihi'
          Visible = True
        end
        object PivotGrid1Yil: TcxDBPivotGridField
          AreaIndex = 14
          IsCaptionAssigned = True
          Caption = 'Y'#305'l'
          DataBinding.FieldName = 'Yil'
          Visible = True
        end
        object PivotGrid1Ay: TcxDBPivotGridField
          AreaIndex = 15
          IsCaptionAssigned = True
          Caption = 'Ay'
          DataBinding.FieldName = 'Ay'
          Visible = True
        end
        object PivotGrid1UstGrup: TcxDBPivotGridField
          Area = faColumn
          AreaIndex = 1
          IsCaptionAssigned = True
          Caption = #220'st Grup'
          DataBinding.FieldName = 'UstGrupId'
          Visible = True
        end
        object PivotGrid1Grup: TcxDBPivotGridField
          Area = faColumn
          AreaIndex = 0
          IsCaptionAssigned = True
          Caption = 'Grup'
          DataBinding.FieldName = 'GrupId'
          Visible = True
        end
        object PivotGrid1UretimDurum: TcxDBPivotGridField
          AreaIndex = 18
          IsCaptionAssigned = True
          Caption = #220'retim Durumu'
          DataBinding.FieldName = 'UretimDurum'
          Visible = True
        end
        object PivotGrid1KargoFirma: TcxDBPivotGridField
          AreaIndex = 22
          IsCaptionAssigned = True
          Caption = 'Kargo Firma'
          DataBinding.FieldName = 'KargoFirma'
          Visible = True
        end
        object PivotGrid1OdemeSekli: TcxDBPivotGridField
          AreaIndex = 23
          IsCaptionAssigned = True
          Caption = #214'deme Tipi'
          DataBinding.FieldName = 'OdemeSekli'
          Visible = True
        end
        object PivotGrid1OkutmaKoli: TcxDBPivotGridField
          AreaIndex = 24
          IsCaptionAssigned = True
          Caption = 'Ba'#287'-Koli'
          DataBinding.FieldName = 'OkutmaKoli'
          Visible = True
        end
        object PivotGrid1KargoFiyat: TcxDBPivotGridField
          AreaIndex = 25
          IsCaptionAssigned = True
          Caption = 'Kargo Fiyat'
          DataBinding.FieldName = 'KargoFiyat'
          Visible = True
        end
        object PivotGrid1SevkAdres: TcxDBPivotGridField
          AreaIndex = 26
          IsCaptionAssigned = True
          Caption = 'Sevk Adres'
          DataBinding.FieldName = 'SevkAdres'
          Visible = True
        end
        object PivotGrid1Sevkilce: TcxDBPivotGridField
          AreaIndex = 27
          IsCaptionAssigned = True
          Caption = 'Sevk il'#231'e'
          DataBinding.FieldName = 'Sevkilce'
          Visible = True
        end
        object PivotGrid1SevkSehir: TcxDBPivotGridField
          AreaIndex = 28
          IsCaptionAssigned = True
          Caption = 'Sevk '#350'ehir'
          DataBinding.FieldName = 'SevkSehir'
          Visible = True
        end
      end
      object Panel3: TPanel
        Left = 0
        Top = 0
        Width = 1061
        Height = 30
        Align = alTop
        BevelOuter = bvLowered
        TabOrder = 1
        DesignSize = (
          1061
          30)
        object SBBBBB1: TSpeedButton
          Left = 1033
          Top = 5
          Width = 23
          Height = 22
          Anchors = [akTop, akRight]
          Flat = True
          OnClick = SBBBBB1Click
        end
        object btListeGetir: TBitBtn
          Left = 9
          Top = 4
          Width = 105
          Height = 22
          Caption = 'Listeyi Getir'
          TabOrder = 0
          OnClick = btListeGetirClick
        end
      end
    end
  end
  object PageControl2: TPageControl
    Left = 0
    Top = 0
    Width = 1069
    Height = 138
    ActivePage = TabSheet1
    Align = alTop
    TabOrder = 2
    object TabSheet1: TTabSheet
      Caption = 'Arama Kriter'
      object Panel1: TPanel
        Left = 0
        Top = 0
        Width = 1061
        Height = 116
        Align = alTop
        BevelOuter = bvNone
        TabOrder = 0
        object Bevel2: TBevel
          Left = 402
          Top = 3
          Width = 217
          Height = 106
          Shape = bsFrame
        end
        object Bevel1: TBevel
          Left = 232
          Top = 3
          Width = 169
          Height = 106
          Shape = bsFrame
        end
        object Bevel4: TBevel
          Left = 621
          Top = 3
          Width = 238
          Height = 106
          Shape = bsFrame
        end
        object Statusul: TLabel
          Left = 5
          Top = 9
          Width = 37
          Height = 14
          Caption = 'Stat'#252's'#252
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Firmaadil: TLabel
          Left = 5
          Top = 57
          Width = 44
          Height = 14
          Caption = 'Firma Ad'#305
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object bastarihl: TLabel
          Left = 240
          Top = 34
          Width = 45
          Height = 14
          Caption = 'Ba'#351'.Tarih'
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Bittarihl: TLabel
          Left = 240
          Top = 57
          Width = 38
          Height = 14
          Caption = 'Bit.Tarih'
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object ambarl: TLabel
          Left = 410
          Top = 9
          Width = 32
          Height = 14
          Caption = 'Ambar'
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Stokkodul: TLabel
          Left = 625
          Top = 9
          Width = 49
          Height = 14
          Caption = 'Stok Kodu'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Carikodul: TLabel
          Left = 625
          Top = 34
          Width = 47
          Height = 14
          Caption = 'Cari Kodu'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Firmaadi2l: TLabel
          Left = 625
          Top = 57
          Width = 44
          Height = 14
          Caption = 'Firma Ad'#305
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Label13: TLabel
          Left = 830
          Top = 33
          Width = 16
          Height = 14
          Caption = '[%]'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
        end
        object Label11: TLabel
          Left = 830
          Top = 10
          Width = 16
          Height = 14
          Caption = '[%]'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
        end
        object Boluml: TLabel
          Left = 5
          Top = 34
          Width = 29
          Height = 14
          Caption = 'B'#246'l'#252'm'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Label1: TLabel
          Left = 410
          Top = 34
          Width = 25
          Height = 14
          Caption = 'Filitre'
          Transparent = True
        end
        object CariTipil: TLabel
          Left = 5
          Top = 79
          Width = 38
          Height = 14
          Caption = 'Cari Tipi'
          Transparent = True
          OnDblClick = TemizleLabel
        end
        object Label39: TLabel
          Left = 867
          Top = 48
          Width = 91
          Height = 18
          Caption = 'Okutulmam'#305#351
          Font.Charset = TURKISH_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Transparent = True
          Visible = False
        end
        object Label40: TLabel
          Left = 867
          Top = 64
          Width = 76
          Height = 18
          Caption = 'Okutulmu'#351
          Font.Charset = TURKISH_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Transparent = True
          Visible = False
        end
        object Label41: TLabel
          Left = 867
          Top = 81
          Width = 51
          Height = 18
          Caption = 'Toplam'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Transparent = True
          Visible = False
        end
        object lblOkutulmamis: TLabel
          Left = 984
          Top = 48
          Width = 18
          Height = 18
          Caption = '[0]'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Transparent = True
          Visible = False
        end
        object lblOkutulmus: TLabel
          Left = 984
          Top = 64
          Width = 18
          Height = 18
          Caption = '[0]'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Transparent = True
          Visible = False
        end
        object lbltoplam: TLabel
          Left = 984
          Top = 81
          Width = 18
          Height = 18
          Caption = '[0]'
          Font.Charset = TURKISH_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Transparent = True
          Visible = False
        end
        object Label42: TLabel
          Left = 410
          Top = 57
          Width = 60
          Height = 14
          Caption = 'Tes. Dur. D'#305#351
          Transparent = True
        end
        object Label3: TLabel
          Left = 410
          Top = 78
          Width = 53
          Height = 14
          Caption = 'Tes. Dur. '#304#231
          Transparent = True
        end
        object Statusuk: TwwDBComboBox
          Left = 53
          Top = 7
          Width = 177
          Height = 22
          ShowButton = True
          Style = csDropDownList
          MapList = True
          AllowClearKey = True
          AutoDropDown = True
          DropDownCount = 8
          ItemHeight = 0
          Items.Strings = (
            #304#351'lem Yap'#305'lmad'#305#9'1'
            'Devam Ediyor'#9'2'
            'Tamamland'#305#9'3')
          Sorted = False
          TabOrder = 0
          UnboundDataType = wwDefault
          OnCloseUp = StatusukCloseUp
        end
        object bastarihk: TwwDBDateTimePicker
          Left = 296
          Top = 30
          Width = 98
          Height = 22
          CalendarAttributes.Font.Charset = DEFAULT_CHARSET
          CalendarAttributes.Font.Color = clWindowText
          CalendarAttributes.Font.Height = -11
          CalendarAttributes.Font.Name = 'MS Sans Serif'
          CalendarAttributes.Font.Style = []
          Epoch = 1950
          ShowButton = True
          TabOrder = 2
          DisplayFormat = 'dd.mm.yyyy'
        end
        object Bittarihk: TwwDBDateTimePicker
          Left = 296
          Top = 53
          Width = 98
          Height = 22
          CalendarAttributes.Font.Charset = DEFAULT_CHARSET
          CalendarAttributes.Font.Color = clWindowText
          CalendarAttributes.Font.Height = -11
          CalendarAttributes.Font.Name = 'MS Sans Serif'
          CalendarAttributes.Font.Style = []
          Epoch = 1950
          ShowButton = True
          TabOrder = 3
          DisplayFormat = 'dd.mm.yyyy'
        end
        object ambark: TwwDBLookupCombo
          Left = 475
          Top = 7
          Width = 140
          Height = 22
          DisableThemes = False
          DropDownAlignment = taLeftJustify
          Selected.Strings = (
            'DepoAdi'#9'20'#9'Depo Ad'#305#9'F'#9)
          LookupTable = dm.AmbarQ
          LookupField = 'id'
          Style = csDropDownList
          Navigator = False
          TabOrder = 4
          AutoDropDown = True
          ShowButton = True
          UseTFields = False
          AllowClearKey = True
          ShowMatchText = True
          OnCloseUp = ambarkCloseUp
        end
        object Firmaadi2k: TEdit
          Left = 681
          Top = 53
          Width = 167
          Height = 21
          AutoSize = False
          TabOrder = 6
        end
        object Bolumk: TwwDBLookupCombo
          Left = 53
          Top = 30
          Width = 177
          Height = 22
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          DisableThemes = False
          DropDownAlignment = taLeftJustify
          Selected.Strings = (
            'isim'#9'30'#9'Filitre 1'#9'F')
          LookupTable = St_AnaGrupQ
          LookupField = 'kod'
          Style = csDropDownList
          Color = clWhite
          Navigator = False
          ParentFont = False
          TabOrder = 1
          AutoDropDown = True
          ShowButton = True
          AllowClearKey = True
          ShowMatchText = True
          OnCloseUp = BolumkCloseUp
        end
        object r1: TRadioButton
          Tag = 3
          Left = 351
          Top = 7
          Width = 46
          Height = 17
          Caption = '1 Y'#305'l'
          TabOrder = 7
          OnClick = r2Click
        end
        object r2: TRadioButton
          Tag = 1
          Left = 239
          Top = 7
          Width = 57
          Height = 17
          Caption = '1 Hafta'
          Checked = True
          TabOrder = 8
          TabStop = True
          OnClick = r2Click
        end
        object r3: TRadioButton
          Tag = 2
          Left = 298
          Top = 7
          Width = 46
          Height = 17
          Caption = '1 Ay'
          TabOrder = 9
          OnClick = r2Click
        end
        object Firmaadik: TwwDBLookupCombo
          Left = 53
          Top = 53
          Width = 177
          Height = 22
          DisableThemes = False
          DropDownAlignment = taLeftJustify
          Selected.Strings = (
            'firmaadi'#9'35'#9'Firma Ad'#305#9'F'
            'carikodu'#9'20'#9'Cari Kodu'#9'F')
          LookupTable = FirmaQ
          LookupField = 'carikod'
          Options = [loColLines, loTitles]
          Style = csDropDownList
          Navigator = False
          TabOrder = 10
          AutoDropDown = True
          ShowButton = True
          UseTFields = False
          AllowClearKey = True
          OnCloseUp = FirmaadikCloseUp
        end
        object filitrek: TwwDBComboBox
          Left = 475
          Top = 30
          Width = 140
          Height = 22
          ShowButton = True
          Style = csDropDownList
          MapList = True
          AllowClearKey = True
          AutoDropDown = True
          DropDownCount = 8
          ItemHeight = 0
          Items.Strings = (
            'Masa'#252'st'#252' Bilgisayar'#9'1'
            'Diz'#252'st'#252' Bilgisayar'#9'2')
          Sorted = False
          TabOrder = 5
          UnboundDataType = wwDefault
          OnCloseUp = filitrekCloseUp
        end
        object StokKoduk: TwwDBComboDlg
          Tag = 1
          Left = 681
          Top = 7
          Width = 143
          Height = 22
          ShowButton = True
          Style = csDropDown
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          TabOrder = 11
          WordWrap = False
          UnboundDataType = wwDefault
          OnKeyPress = StokKodukKeyPress
        end
        object carikoduk: TwwDBComboDlg
          Tag = 10000
          Left = 681
          Top = 30
          Width = 143
          Height = 22
          ShowButton = True
          Style = csDropDown
          Font.Charset = TURKISH_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          TabOrder = 12
          WordWrap = False
          UnboundDataType = wwDefault
          OnKeyPress = carikodukKeyPress
        end
        object CariTipiK: TwwDBComboBox
          Left = 53
          Top = 74
          Width = 177
          Height = 22
          ShowButton = True
          Style = csDropDown
          MapList = True
          AllowClearKey = True
          AutoDropDown = True
          DropDownCount = 8
          ItemHeight = 0
          Sorted = False
          TabOrder = 13
          UnboundDataType = wwDefault
          OnCloseUp = CariTipiKCloseUp
        end
        object TesDurum: TwwDBComboBox
          Left = 475
          Top = 53
          Width = 140
          Height = 22
          ShowButton = True
          Style = csDropDownList
          MapList = True
          AllowClearKey = True
          AutoDropDown = True
          DropDownCount = 8
          ItemHeight = 0
          Items.Strings = (
            'Yolda'#9'1'
            'Teslim Edildi'#9'2')
          Sorted = False
          TabOrder = 14
          UnboundDataType = wwDefault
          OnCloseUp = filitrekCloseUp
        end
        object edTesDurumIC: TwwDBComboBox
          Left = 475
          Top = 74
          Width = 140
          Height = 22
          ShowButton = True
          Style = csDropDownList
          MapList = True
          AllowClearKey = True
          AutoDropDown = True
          DropDownCount = 8
          ItemHeight = 0
          Items.Strings = (
            'Haz'#305'r'#9'3'
            'Haz'#305'r De'#287'il'#9'0')
          Sorted = False
          TabOrder = 15
          UnboundDataType = wwDefault
          OnCloseUp = filitrekCloseUp
        end
        object btIrsaliyeIcerik: TwwCheckBox
          Left = 632
          Top = 74
          Width = 97
          Height = 17
          DisableThemes = False
          AlwaysTransparent = False
          ValueChecked = 'True'
          ValueUnchecked = 'False'
          DisplayValueChecked = 'True'
          DisplayValueUnchecked = 'False'
          NullAndBlankState = cbUnchecked
          Caption = #304'rsaliye '#304#231'erikleri G'#246'ster'
          TabOrder = 16
        end
        object cbSeriNoluListele: TCheckBox
          Left = 739
          Top = 74
          Width = 114
          Height = 17
          Caption = 'Seri Nolu Listele'
          TabOrder = 17
        end
        object pnlNusha: TPanel
          Tag = 1035
          Left = 860
          Top = 2
          Width = 174
          Height = 46
          BevelOuter = bvNone
          TabOrder = 18
          object GroupBox1: TGroupBox
            Left = 0
            Top = 0
            Width = 174
            Height = 46
            Align = alClient
            Caption = '  Alt N'#252'sha Okutma  '
            TabOrder = 0
            Visible = False
            object Label4: TLabel
              Left = 5
              Top = 23
              Width = 36
              Height = 14
              Caption = #304'rs./Fat.'
            end
            object edAltNusha: TEdit
              Left = 44
              Top = 18
              Width = 121
              Height = 22
              TabStop = False
              TabOrder = 0
              OnKeyPress = edAltNushaKeyPress
            end
          end
        end
        object cbUretimDurum: TCheckBox
          Left = 739
          Top = 90
          Width = 114
          Height = 17
          Caption = #220'retim Emir Durumlu'
          TabOrder = 19
          Visible = False
        end
        object cbKargoFiyat: TCheckBox
          Left = 319
          Top = 84
          Width = 77
          Height = 17
          Caption = 'Kargo Fiyat'
          TabOrder = 20
        end
        object cbKargoDesi: TCheckBox
          Left = 238
          Top = 84
          Width = 80
          Height = 17
          Caption = 'Kargo Desi'
          TabOrder = 21
        end
        object cbSonKontrol: TCheckBox
          Left = 632
          Top = 90
          Width = 97
          Height = 17
          TabStop = False
          Caption = 'Son Kontrol'
          TabOrder = 22
        end
      end
    end
    object TabSheet2: TTabSheet
      Caption = 'Arama Kriter 2'
      ImageIndex = 1
      object Label8: TLabel
        Left = 5
        Top = 0
        Width = 62
        Height = 14
        Caption = 'Bilgi '#304#351'lem No'
        Transparent = True
      end
      object Label9: TLabel
        Left = 198
        Top = 0
        Width = 57
        Height = 14
        Caption = 'UPS Barkod'
        Transparent = True
        Visible = False
      end
      object mmBilisno: TMemo
        Left = 2
        Top = 16
        Width = 160
        Height = 86
        TabOrder = 0
      end
      object mmUpsBarkod: TMemo
        Left = 195
        Top = 16
        Width = 160
        Height = 86
        TabOrder = 1
        Visible = False
      end
    end
  end
  object FirmaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'select carikod,carikodu,firmaadi from cari'
      'order by firmaadi')
    Left = 824
    Top = 327
  end
  object FaturaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 3000
    Parameters = <>
    SQL.Strings = (
      
        'Select FirmaKodu=C.Carikodu, C.firmaadi,COzelkod=C.temsilcisi,C.' +
        'Ozelkod2 COzelkod2,C.Ozelkod5 COzelkod5,   SevkKodu=(select top ' +
        '1 KODU from tbl_sevkiyatadres where UNITYCODE=FF.sevkiyatkod),  ' +
        'SevkAciklama=(select top 1 ACIKLAMA from tbl_sevkiyatadres where' +
        ' UNITYCODE=FF.sevkiyatkod),  Adres=(select top 1 adres from cari' +
        ' where carikod=FF.carikod),  Sehir=(select top 1 Sehir from cari' +
        ' where carikod=FF.carikod),  ambaradi=(select top 1 depoadi from' +
        ' depolar with(nolock) where depolar.id=FF.ambar),   subeidx=isnu' +
        'll((select top 1 subeid from depolar with(nolock) where depolar.' +
        'id=FF.ambar),1)   ,FF.Durum,FF.Har_Durumu, (Case FF.Har_Durumu W' +
        'hen '#39'1'#39' Then '#39'Yolda'#39' When '#39'2'#39' Then '#39'Teslim Edildi'#39' Else   (Case ' +
        'FF.Durum When '#39'3'#39' Then '#39'Haz'#305'r'#39' Else '#39'Haz'#305'r De'#287'il'#39#39'#9'#39'End) End) a' +
        's Har_Durumux,   FH.SeriNos,Miktar=1,FH.MusteriFaturaTarihi, Fhr' +
        '.Stokkodu,Fhr.Cinsi,Fhr.Miktar,  FF.*, D1=FF.Durum,D2=FF.Har_Dur' +
        'umu From   fatura FF  with(nolock)   Left Join Cari C on (C.Cari' +
        'kod=FF.Carikod)  Left Join fathar FHR on (FHR.bilisno=FF.BilisNo'
      
        ')  Left Join fatharhar FH on ((FH.bilisnocik=FF.BilisNo and FHR.' +
        'Stokkod=Fh.Stokkod) and ((makinano='#39'0'#39') or (makinano is null) or' +
        ' (makinano='#39'M'#39')))  where FF.giristipi=2  and FF.faturatipi=8  an' +
        'd FF.tarih>='#39'01.06.2010 '#39'  and FF.tarih<'#39'02.06.2010 '#39'  and dbo.g' +
        'etcarikodu(FF.carikod) like '#39'tt-%'#39'  order by FF.bilisno desc')
    Left = 816
    Top = 271
  end
  object FaturaQS: TDataSource
    DataSet = FaturaQ
    Left = 728
    Top = 264
  end
  object St_AnaGrupQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'select * from St_AnaGrup')
    Left = 728
    Top = 309
  end
  object FaturaBulQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    Left = 888
    Top = 269
  end
  object PopupMenu1: TPopupMenu
    OnPopup = PopupMenu1Popup
    Left = 272
    Top = 280
    object pbelgeekle: TMenuItem
      Tag = 1010
      Caption = 'Ekle'
      OnClick = pbelgeekleClick
    end
    object PMduzelt: TMenuItem
      Tag = 1011
      Caption = 'D'#252'zelt'
      OnClick = PMduzeltClick
    end
    object PMiptal: TMenuItem
      Tag = 1013
      Caption = #304'ptal'
      OnClick = PMiptalClick
    end
    object KanalGelitirmeExport1: TMenuItem
      Caption = 'Kanal Geli'#351'tirme Export'
      OnClick = KanalGelitirmeExport1Click
    end
    object PmirsnoDegistir: TMenuItem
      Tag = 1014
      Caption = 'Unity '#304'rsaliye No De'#287'i'#351'tir'
      OnClick = PmirsnoDegistirClick
    end
    object PmFaturaNoDegistir: TMenuItem
      Tag = 1015
      Caption = 'Unity Fatura No De'#287'i'#351'tir'
      HelpContext = 1
      OnClick = PmirsnoDegistirClick
    end
    object pmCarikoduDegistir: TMenuItem
      Tag = 1019
      Caption = 'Carikodu De'#287'i'#351'tir'
      OnClick = pmCarikoduDegistirClick
    end
    object PmAciklamaDegistir: TMenuItem
      Tag = 1019
      Caption = 'A'#231#305'klama De'#287'i'#351'tir'
      OnClick = PmAciklamaDegistirClick
    end
    object Pmirsaliyeyazdir: TMenuItem
      Tag = 1016
      Caption = #304'rsaliye Yazd'#305'r'
      ShortCut = 16464
      OnClick = PmirsaliyeyazdirClick
    end
    object pmEltdenTeslimat1: TMenuItem
      Tag = 1030
      Caption = 'Elden Teslimat Yap'
      OnClick = pmEltdenTeslimat1Click
    end
    object pmOkutulduYap1: TMenuItem
      Tag = 1030
      Caption = 'Okutuldu Yap'
      OnClick = pmOkutulduYap1Click
    end
    object CekiExcel1: TMenuItem
      Caption = 'Fatura Excel'
      OnClick = CekiExcel1Click
    end
    object pmiCekiYazdir: TMenuItem
      Caption = #199'eki Yazd'#305'r'
      OnClick = pmiCekiYazdirClick
    end
    object pmSeriExport: TMenuItem
      Tag = 1020
      Caption = 'SeriNo Export'
      OnClick = pmSeriExportClick
    end
    object N1: TMenuItem
      Caption = '-'
    end
  end
  object adoKargoYICI: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'FNO'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      'select  * from tbl_KARGO_YICI '
      'where SEVK_IRSALIYE_NO =:FNO')
    Left = 632
    Top = 311
  end
  object DSAdoKargoYICI: TDataSource
    DataSet = adoKargoYICI
    Left = 552
    Top = 312
  end
  object DSAdoKargoEXP: TDataSource
    DataSet = adoKargoEXP
    Left = 552
    Top = 264
  end
  object adoKargoEXP: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'FNO'
        Attributes = [paNullable]
        DataType = ftWideString
        NumericScale = 255
        Precision = 255
        Size = 10
        Value = Null
      end>
    SQL.Strings = (
      'select   * from tbl_KARGO_EXP'
      'where [irsaliye no] =:FNO')
    Left = 632
    Top = 263
  end
  object pmKargo: TPopupMenu
    Left = 184
    Top = 280
    object mnStokKargoRaporu: TMenuItem
      Caption = 'Stok Kargo Raporu'
    end
  end
  object adoTemp: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    Left = 184
    Top = 335
  end
  object DS: TDataSource
    DataSet = adoFatura
    Left = 337
    Top = 396
  end
  object ppIRSALIYE: TppReport
    AutoStop = False
    DataPipeline = ppDBPipeline1
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'Custom'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 280000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 119
    Units = utMillimeters
    DeviceType = 'Printer'
    EmailSettings.ReportFormat = 'PDF'
    ModalCancelDialog = False
    ModalPreview = False
    OutlineSettings.CreateNode = True
    OutlineSettings.CreatePageNodes = True
    OutlineSettings.Enabled = True
    OutlineSettings.Visible = True
    ShowCancelDialog = False
    ShowPrintDialog = False
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = True
    Left = 408
    Top = 400
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppDBPipeline1'
    object ppTitleBand3: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 44186
      mmPrintPosition = 0
    end
    object ppHeaderBand3: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 57415
      mmPrintPosition = 0
      object ppLabel17: TppLabel
        UserName = 'Label8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #220'nvan :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 9260
        mmTop = 2117
        mmWidth = 9260
        BandType = 0
      end
      object ppDBText27: TppDBText
        UserName = 'DBText14'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'firmaadi'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 20108
        mmTop = 2117
        mmWidth = 69321
        BandType = 0
      end
      object ppLabel18: TppLabel
        UserName = 'Label9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Adres :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 9790
        mmTop = 7673
        mmWidth = 8731
        BandType = 0
      end
      object ppDBMemo3: TppDBMemo
        UserName = 'DBMemo2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        CharWrap = False
        DataField = 'Adres'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 13494
        mmLeft = 20108
        mmTop = 7673
        mmWidth = 69056
        BandType = 0
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        mmLeading = 0
      end
      object ppLabel19: TppLabel
        UserName = 'Label10'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #304'l'#231'e / '#304'l :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 9260
        mmTop = 21696
        mmWidth = 9525
        BandType = 0
      end
      object ppDBText28: TppDBText
        UserName = 'DBText15'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'ilce'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 20108
        mmTop = 21696
        mmWidth = 21431
        BandType = 0
      end
      object ppDBText29: TppDBText
        UserName = 'DBText16'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'sehir'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 46831
        mmTop = 21696
        mmWidth = 21167
        BandType = 0
      end
      object ppLabel20: TppLabel
        UserName = 'Label11'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = ' / '
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 43392
        mmTop = 21696
        mmWidth = 2381
        BandType = 0
      end
      object ppLabel21: TppLabel
        UserName = 'Label12'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'V.D / V.No :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 3969
        mmTop = 26458
        mmWidth = 14552
        BandType = 0
      end
      object ppDBText30: TppDBText
        UserName = 'DBText17'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'vergidaire'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 20108
        mmTop = 26458
        mmWidth = 39688
        BandType = 0
      end
      object ppLabel22: TppLabel
        UserName = 'Label13'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = ' / '
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 61648
        mmTop = 26458
        mmWidth = 2381
        BandType = 0
      end
      object ppDBText31: TppDBText
        UserName = 'DBText101'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'vergino'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 66146
        mmTop = 26458
        mmWidth = 23019
        BandType = 0
      end
      object ppDBText32: TppDBText
        UserName = 'DBText19'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Telefon3'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 20108
        mmTop = 31221
        mmWidth = 39688
        BandType = 0
      end
      object ppLabel23: TppLabel
        UserName = 'Label14'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Tel :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 13229
        mmTop = 31221
        mmWidth = 5292
        BandType = 0
      end
      object ppDBText33: TppDBText
        UserName = 'DBText20'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Carikodu'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 19844
        mmTop = 40217
        mmWidth = 69586
        BandType = 0
      end
      object ppDBText34: TppDBText
        UserName = 'DBText21'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Har_Gonderino'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 146315
        mmTop = 26988
        mmWidth = 38100
        BandType = 0
      end
      object ppDBText35: TppDBText
        UserName = 'DBText22'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Ftarih'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 146315
        mmTop = 15875
        mmWidth = 38100
        BandType = 0
      end
      object ppDBText36: TppDBText
        UserName = 'DBText23'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Bugun'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 146315
        mmTop = 10054
        mmWidth = 38100
        BandType = 0
      end
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'odemesekli'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 146050
        mmTop = 5027
        mmWidth = 38365
        BandType = 0
      end
      object ppLabel1: TppLabel
        UserName = 'Label1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'K. No :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3260
        mmLeft = 9800
        mmTop = 35719
        mmWidth = 8721
        BandType = 0
      end
      object ppDBText3: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'TcKimlikNo'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 20108
        mmTop = 35719
        mmWidth = 39688
        BandType = 0
      end
      object ppDBText20: TppDBText
        UserName = 'DBText8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Kargofirma'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 12
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 5027
        mmLeft = 146844
        mmTop = 32808
        mmWidth = 38894
        BandType = 0
      end
    end
    object ppDetailBand3: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 3440
      mmPrintPosition = 0
      object ppDBText37: TppDBText
        UserName = 'DBText24'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Stokkodu'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 5292
        mmTop = 265
        mmWidth = 38100
        BandType = 4
      end
      object ppDBText38: TppDBText
        UserName = 'DBText25'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cinsi'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 50800
        mmTop = 265
        mmWidth = 71967
        BandType = 4
      end
      object ppDBText39: TppDBText
        UserName = 'DBText26'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'miktar'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 143934
        mmTop = 265
        mmWidth = 38100
        BandType = 4
      end
    end
    object ppFooterBand2: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 85461
      mmPrintPosition = 0
      object ppDBText15: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'SevkAdi'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 51065
        mmTop = 265
        mmWidth = 130704
        BandType = 8
      end
      object ppDBMemo1: TppDBMemo
        UserName = 'DBMemo1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        CharWrap = False
        DataField = 'SevkAdresi'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 6615
        mmLeft = 7408
        mmTop = 3969
        mmWidth = 174625
        BandType = 8
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        mmLeading = 0
      end
      object ppDBText16: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'SevkKodu'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3260
        mmLeft = 7408
        mmTop = 265
        mmWidth = 41010
        BandType = 8
      end
      object ppDBText17: TppDBText
        UserName = 'DBText6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'ILCEAD'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3260
        mmLeft = 7408
        mmTop = 15081
        mmWidth = 41010
        BandType = 8
      end
      object ppDBText18: TppDBText
        UserName = 'DBText18'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'SEHIRAD'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 49742
        mmTop = 15081
        mmWidth = 41010
        BandType = 8
      end
      object ppLabel29: TppLabel
        UserName = 'Label29'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = '/'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3260
        mmLeft = 48683
        mmTop = 15346
        mmWidth = 804
        BandType = 8
      end
      object ppLabel30: TppLabel
        UserName = 'Label30'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = '/'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3260
        mmLeft = 49213
        mmTop = 265
        mmWidth = 804
        BandType = 8
      end
      object lblAciklama: TppLabel
        UserName = 'lblAciklama'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        WordWrap = True
        mmHeight = 10054
        mmLeft = 7408
        mmTop = 27252
        mmWidth = 174361
        BandType = 8
      end
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Kargofirma'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3260
        mmLeft = 149490
        mmTop = 23019
        mmWidth = 32279
        BandType = 8
      end
      object ppDBText19: TppDBText
        UserName = 'DBText7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Yolbilgi'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 7408
        mmTop = 23548
        mmWidth = 139171
        BandType = 8
      end
      object ppDBText70: TppDBText
        UserName = 'DBText70'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'SEVKTEL1'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3260
        mmLeft = 7144
        mmTop = 10848
        mmWidth = 41010
        BandType = 8
      end
      object ppDBText71: TppDBText
        UserName = 'DBText71'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'SEVKTEL2'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3175
        mmLeft = 49477
        mmTop = 10848
        mmWidth = 41010
        BandType = 8
      end
      object ppLabel39: TppLabel
        UserName = 'Label39'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = '/'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3260
        mmLeft = 48419
        mmTop = 10848
        mmWidth = 804
        BandType = 8
      end
    end
    object ppSummaryBand3: TppSummaryBand
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
  end
  object ppDBPipeline1: TppDBPipeline
    DataSource = DS
    UserName = 'Fatura1'
    Left = 484
    Top = 400
    object ppDBPipeline1ppField1: TppField
      FieldAlias = 'Bugun'
      FieldName = 'Bugun'
      FieldLength = 0
      DisplayWidth = 0
      Position = 0
    end
    object ppDBPipeline1ppField2: TppField
      FieldAlias = 'Kargofirma'
      FieldName = 'Kargofirma'
      FieldLength = 50
      DisplayWidth = 50
      Position = 1
    end
    object ppDBPipeline1ppField3: TppField
      FieldAlias = 'Ftarih'
      FieldName = 'Ftarih'
      FieldLength = 30
      DisplayWidth = 30
      Position = 2
    end
    object ppDBPipeline1ppField4: TppField
      FieldAlias = 'Har_Gonderino'
      FieldName = 'Har_Gonderino'
      FieldLength = 30
      DisplayWidth = 30
      Position = 3
    end
    object ppDBPipeline1ppField5: TppField
      FieldAlias = 'odemesekli'
      FieldName = 'odemesekli'
      FieldLength = 10
      DisplayWidth = 10
      Position = 4
    end
    object ppDBPipeline1ppField6: TppField
      FieldAlias = 'TcKimlikNo'
      FieldName = 'TcKimlikNo'
      FieldLength = 11
      DisplayWidth = 11
      Position = 5
    end
    object ppDBPipeline1ppField7: TppField
      FieldAlias = 'tarih'
      FieldName = 'tarih'
      FieldLength = 0
      DataType = dtDateTime
      DisplayWidth = 18
      Position = 6
    end
    object ppDBPipeline1ppField8: TppField
      FieldAlias = 'ilce'
      FieldName = 'ilce'
      FieldLength = 20
      DisplayWidth = 20
      Position = 7
    end
    object ppDBPipeline1ppField9: TppField
      FieldAlias = 'sehir'
      FieldName = 'sehir'
      FieldLength = 20
      DisplayWidth = 20
      Position = 8
    end
    object ppDBPipeline1ppField10: TppField
      FieldAlias = 'Carikodu'
      FieldName = 'Carikodu'
      FieldLength = 20
      DisplayWidth = 20
      Position = 9
    end
    object ppDBPipeline1ppField11: TppField
      FieldAlias = 'vergidaire'
      FieldName = 'vergidaire'
      FieldLength = 20
      DisplayWidth = 20
      Position = 10
    end
    object ppDBPipeline1ppField12: TppField
      FieldAlias = 'vergino'
      FieldName = 'vergino'
      FieldLength = 15
      DisplayWidth = 15
      Position = 11
    end
    object ppDBPipeline1ppField13: TppField
      FieldAlias = 'Telefon3'
      FieldName = 'Telefon3'
      FieldLength = 15
      DisplayWidth = 15
      Position = 12
    end
    object ppDBPipeline1ppField14: TppField
      FieldAlias = 'Adres'
      FieldName = 'Adres'
      FieldLength = 150
      DisplayWidth = 150
      Position = 13
    end
    object ppDBPipeline1ppField15: TppField
      FieldAlias = 'firmaadi'
      FieldName = 'firmaadi'
      FieldLength = 60
      DisplayWidth = 60
      Position = 14
    end
    object ppDBPipeline1ppField16: TppField
      FieldAlias = 'Stokkodu'
      FieldName = 'Stokkodu'
      FieldLength = 25
      DisplayWidth = 25
      Position = 15
    end
    object ppDBPipeline1ppField17: TppField
      FieldAlias = 'cinsi'
      FieldName = 'cinsi'
      FieldLength = 50
      DisplayWidth = 50
      Position = 16
    end
    object ppDBPipeline1ppField18: TppField
      Alignment = taRightJustify
      FieldAlias = 'miktar'
      FieldName = 'miktar'
      FieldLength = 0
      DataType = dtDouble
      DisplayWidth = 10
      Position = 17
    end
    object ppDBPipeline1ppField19: TppField
      FieldAlias = 'har_belgeturu'
      FieldName = 'har_belgeturu'
      FieldLength = 4
      DisplayWidth = 4
      Position = 18
    end
    object ppDBPipeline1ppField20: TppField
      FieldAlias = 'Aciklama'
      FieldName = 'Aciklama'
      FieldLength = 200
      DisplayWidth = 200
      Position = 19
    end
    object ppDBPipeline1ppField21: TppField
      FieldAlias = 'Yolbilgi'
      FieldName = 'Yolbilgi'
      FieldLength = 255
      DisplayWidth = 255
      Position = 20
    end
  end
  object adoFaturaTemp: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    Left = 284
    Top = 399
  end
  object adoFatura: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'Yol'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 255
        Value = Null
      end
      item
        Name = 'BILISNO'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'select convert(varchar,Getdate(),104) as Bugun,'
      'SevkKodu=Sa.KODU,'
      'SevkAdi=Sa.ACIKLAMA,'
      'SevkAdresi=(Sa.ADRES1 + '#39' '#39' + Sa.ADRES2),'
      'SEVKTEL1=Sa.TEl1,SEVKTEL2=Sa.Tel2,'
      'Sa.ILCEAD,Sa.SEHIRAD,'
      
        'Kargofirma=(Select Top 1 Ad from tbl_KargoTanim Where ID=F.Kargo' +
        '),'
      
        'convert(varchar,F.tarih,104) as Ftarih,F.Har_Gonderino,odemesekl' +
        'i,C.TcKimlikNo,F.Ozelkod,F.BelgeNo,'
      
        'F.tarih,C.ilce,C.sehir,C.Carikodu,C.vergidaire,C.vergino,C.Telef' +
        'on3,C.Adres,C.firmaadi,S.Stokkodu,S.cinsi,Ft.miktar,F.har_belget' +
        'uru,F.Aciklama '
      ',Yolbilgi=:Yol from fatura F '
      'join Cari C on C.carikod=F.carikod'
      'join Fathar FT on FT.bilisno=F.bilisno'
      'join Stok S on S.stokkod=FT.Stokkod'
      'Left join tbl_sevkiyatadres Sa on Sa.UNITYCODE=F.sevkiyatkod'
      ' where F.bilisno = :BILISNO')
    Left = 416
    Top = 336
  end
  object dsCekiList: TDataSource
    DataSet = aqCekiList
    Left = 461
    Top = 195
  end
  object aqCekiList: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 300
    Parameters = <
      item
        Name = 'bilisno'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      
        'select Bilisno,Tarih,Har_GonderiNo,OkutmaKoli,SevkiyatKodu,C.ACI' +
        'KLAMA FirmaAdi,C.Adres1+'#39' '#39'+Adres2 Adres,C.ILCEAD ilce,C.SEHIRAD' +
        ' Sehir,C.TEL1 telefon3,C.TEL2 Telefon2,C.ILCEAD+'#39' / '#39'+C.SEHIRAD ' +
        'ilceil,C.TEL1+'#39' / '#39'+C.TEL2 Tel,'
      
        'Paletno,st.Stokkodu,st.Cinsi,Count(St.Stokkod) Miktar,1 PaletTop' +
        'lam,St.Barkod,st.Desi,st.Net,st.Brut,'
      
        '(select top 1 aciklamasatis From unity_siparis_2006 where Sipari' +
        'sNo=(select Belgeno from fatura where bilisno=f.bilisno)) Muster' +
        'iSiparisno'
      'from fatura f'
      'left join fatharhar fhh on (f.bilisno=fhh.bilisnocik)'
      'left join Stok st on (st.Stokkod=fhh.Stokkod)'
      'left join tbl_sevkiyatadres c on (c.UNITYCODE=F.sevkiyatkod)'
      'where'
      
        'Belgeno in (select SiparisNo From unity_siparis_2006 where acikl' +
        'amasatis in'
      
        '(select aciklamasatis From unity_siparis_2006 where SiparisNo=(s' +
        'elect Belgeno from fatura where bilisno=:bilisno)))'
      'and PaletNo is not null'
      'and st.UstGrupId<>7'
      'Group By Bilisno,Tarih,Har_GonderiNo,OkutmaKoli,SevkiyatKodu,'
      'C.ACIKLAMA,C.Adres1,Adres2,C.ILCEAD,C.SEHIRAD,C.TEL1,C.TEL2,'
      'Paletno,st.Stokkodu,st.Cinsi,St.Barkod,st.Desi,st.Net,st.Brut'
      'order by Paletno')
    Left = 409
    Top = 192
  end
  object ppDBPipeCeki: TppDBPipeline
    DataSource = dsCekiList
    UserName = 'DBPipeCeki'
    Left = 340
    Top = 192
  end
  object ppCekiList: TppReport
    AutoStop = False
    DataPipeline = ppDBPipeCeki
    PassSetting = psTwoPass
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'Custom'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 280000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 119
    Units = utMillimeters
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    ModalCancelDialog = False
    ModalPreview = False
    OutlineSettings.CreateNode = True
    OutlineSettings.CreatePageNodes = True
    OutlineSettings.Enabled = True
    OutlineSettings.Visible = True
    ShowCancelDialog = False
    ShowPrintDialog = False
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = True
    Left = 275
    Top = 191
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppDBPipeCeki'
    object ppHeaderBand1: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 33867
      mmPrintPosition = 0
      object ppLabel6: TppLabel
        UserName = 'Label6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #199'EK'#304' L'#304'STES'#304
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 18
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 7535
        mmLeft = 1852
        mmTop = 1058
        mmWidth = 40979
        BandType = 0
      end
      object ppShape1: TppShape
        UserName = 'Shape1'
        mmHeight = 14817
        mmLeft = 1058
        mmTop = 8731
        mmWidth = 97896
        BandType = 0
      end
      object ppDBText5: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Tarih'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3175
        mmLeft = 146844
        mmTop = 4763
        mmWidth = 46038
        BandType = 0
      end
      object ppShape2: TppShape
        UserName = 'Shape2'
        mmHeight = 14817
        mmLeft = 98690
        mmTop = 8731
        mmWidth = 98000
        BandType = 0
      end
      object ppShape3: TppShape
        UserName = 'Shape3'
        mmHeight = 10583
        mmLeft = 1058
        mmTop = 23019
        mmWidth = 97896
        BandType = 0
      end
      object ppShape4: TppShape
        UserName = 'Shape4'
        mmHeight = 10583
        mmLeft = 98690
        mmTop = 23019
        mmWidth = 97896
        BandType = 0
      end
      object ppLabel7: TppLabel
        UserName = 'Label7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'G'#246'nderilen :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4191
        mmLeft = 1852
        mmTop = 9525
        mmWidth = 20743
        BandType = 0
      end
      object ppLabel8: TppLabel
        UserName = 'Label1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'G'#246'nderen :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4191
        mmLeft = 99484
        mmTop = 9525
        mmWidth = 18796
        BandType = 0
      end
      object ppVariable1: TppVariable
        UserName = 'PaletToplam'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        BlankWhenZero = False
        CalcOrder = 0
        CalcType = veReportEnd
        DataType = dtInteger
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        LookAhead = True
        ResetType = veReportStart
        Transparent = True
        mmHeight = 4022
        mmLeft = 123825
        mmTop = 23548
        mmWidth = 19770
        BandType = 0
      end
      object ppDBCalc2: TppDBCalc
        UserName = 'DBCalc2'
        AutoSize = True
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Miktar'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        LookAhead = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 4022
        mmLeft = 123825
        mmTop = 28310
        mmWidth = 19262
        BandType = 0
      end
      object ppLabel11: TppLabel
        UserName = 'Label101'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Toplam Palet '
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 99748
        mmTop = 23548
        mmWidth = 21717
        BandType = 0
      end
      object ppLabel12: TppLabel
        UserName = 'Label10'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Toplam '#220'r'#252'n  '
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 100013
        mmTop = 28310
        mmWidth = 22352
        BandType = 0
      end
      object ppLabel13: TppLabel
        UserName = 'Label11'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = ':'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 122238
        mmTop = 23283
        mmWidth = 974
        BandType = 0
      end
      object ppLabel14: TppLabel
        UserName = 'Label12'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = ':'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 122238
        mmTop = 28310
        mmWidth = 974
        BandType = 0
      end
      object ppLabel15: TppLabel
        UserName = 'Label13'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'CASPER BILGISAYAR SISTEMLERI A.'#350'.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 118798
        mmTop = 9525
        mmWidth = 65574
        BandType = 0
      end
      object ppLabel16: TppLabel
        UserName = 'Label16'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 
          'Casper Plaza '#199'akmak Mah. Balkan Cad. No:49         Tepe'#252'st'#252' / '#220'm' +
          'raniye / '#304'stanbul '
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        WordWrap = True
        mmHeight = 8202
        mmLeft = 99484
        mmTop = 14288
        mmWidth = 96044
        BandType = 0
      end
      object ppDBText4: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'FirmaAdi'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3969
        mmLeft = 23019
        mmTop = 9525
        mmWidth = 74877
        BandType = 0
      end
      object ppDBText10: TppDBText
        UserName = 'DBText10'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Adres'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 7
        Font.Style = []
        Transparent = True
        WordWrap = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 6085
        mmLeft = 1852
        mmTop = 13758
        mmWidth = 96044
        BandType = 0
      end
      object ppDBText11: TppDBText
        UserName = 'DBText11'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'ilceil'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3175
        mmLeft = 12700
        mmTop = 19844
        mmWidth = 34396
        BandType = 0
      end
      object ppDBText12: TppDBText
        UserName = 'DBText12'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Tel'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3175
        mmLeft = 53711
        mmTop = 19844
        mmWidth = 44186
        BandType = 0
      end
      object ppLabel25: TppLabel
        UserName = 'Label25'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Tel :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3387
        mmLeft = 47361
        mmTop = 19844
        mmWidth = 5842
        BandType = 0
      end
      object ppLabel26: TppLabel
        UserName = 'Label26'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #304'l'#231'e / '#304'l :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3387
        mmLeft = 1852
        mmTop = 19844
        mmWidth = 10541
        BandType = 0
      end
      object ppLabel28: TppLabel
        UserName = 'Label28'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Sipari'#351' No :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 2117
        mmTop = 26194
        mmWidth = 19315
        BandType = 0
      end
      object ppDBText14: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'MusteriSiparisno'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 11
        Font.Style = [fsBold]
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 4498
        mmLeft = 22225
        mmTop = 26194
        mmWidth = 74877
        BandType = 0
      end
    end
    object ppDetailBand1: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 4498
      mmPrintPosition = 0
      object ppDBText6: TppDBText
        UserName = 'DBText6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Barkod'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3260
        mmLeft = 529
        mmTop = 794
        mmWidth = 37571
        BandType = 4
      end
      object ppDBText7: TppDBText
        UserName = 'DBText7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Cinsi'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3175
        mmLeft = 76200
        mmTop = 794
        mmWidth = 60061
        BandType = 4
      end
      object ppDBText8: TppDBText
        UserName = 'DBText8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Miktar'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3175
        mmLeft = 136525
        mmTop = 794
        mmWidth = 7938
        BandType = 4
      end
      object ppLabel10: TppLabel
        UserName = 'Label9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'AD'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 3175
        mmLeft = 148167
        mmTop = 794
        mmWidth = 3969
        BandType = 4
      end
      object ppDBText13: TppDBText
        UserName = 'DBText13'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'Stokkodu'
        DataPipeline = ppDBPipeCeki
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeCeki'
        mmHeight = 3175
        mmLeft = 38629
        mmTop = 1323
        mmWidth = 37835
        BandType = 4
      end
    end
    object ppFooterBand1: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
    object ppGroup1: TppGroup
      BreakName = 'Paletno'
      DataPipeline = ppDBPipeCeki
      KeepTogether = True
      OutlineSettings.CreateNode = True
      UserName = 'Group1'
      mmNewColumnThreshold = 0
      mmNewPageThreshold = 0
      DataPipelineName = 'ppDBPipeCeki'
      object ppGroupHeaderBand1: TppGroupHeaderBand
        mmBottomOffset = 0
        mmHeight = 14023
        mmPrintPosition = 0
        object ppDBText9: TppDBText
          Tag = 1
          UserName = 'DBText9'
          AutoSize = True
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'Paletno'
          DataPipeline = ppDBPipeCeki
          DisplayFormat = '0000000000'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 14
          Font.Style = [fsBold]
          Transparent = True
          DataPipelineName = 'ppDBPipeCeki'
          mmHeight = 6085
          mmLeft = 21960
          mmTop = 4233
          mmWidth = 18521
          BandType = 3
          GroupNo = 0
        end
        object ppLabel2: TppLabel
          UserName = 'Label2'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          Caption = 'Pallet'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 14
          Font.Style = [fsBold]
          Transparent = True
          mmHeight = 5842
          mmLeft = 5027
          mmTop = 3969
          mmWidth = 13250
          BandType = 3
          GroupNo = 0
        end
        object ppLabel3: TppLabel
          UserName = 'Label3'
          AutoSize = False
          Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom]
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = True
          Border.Weight = 1.000000000000000000
          Caption = 'EAN / UPC'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 529
          mmTop = 10054
          mmWidth = 38365
          BandType = 3
          GroupNo = 0
        end
        object ppLabel4: TppLabel
          UserName = 'Label4'
          AutoSize = False
          Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom]
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = True
          Border.Weight = 1.000000000000000000
          Caption = ' Cinsi'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 75936
          mmTop = 10054
          mmWidth = 60325
          BandType = 3
          GroupNo = 0
        end
        object ppLabel5: TppLabel
          UserName = 'Label5'
          AutoSize = False
          Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom]
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = True
          Border.Weight = 1.000000000000000000
          Caption = ' Miktar'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 135732
          mmTop = 10054
          mmWidth = 10319
          BandType = 3
          GroupNo = 0
        end
        object ppLabel9: TppLabel
          UserName = 'Label8'
          AutoSize = False
          Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom]
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = True
          Border.Weight = 1.000000000000000000
          Caption = ' Birim'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 145257
          mmTop = 10054
          mmWidth = 9525
          BandType = 3
          GroupNo = 0
        end
        object ppVariable2: TppVariable
          UserName = 'PaletTpl'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          BlankWhenZero = False
          CalcOrder = 0
          DataType = dtInteger
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 14
          Font.Style = []
          Transparent = True
          Visible = False
          mmHeight = 6085
          mmLeft = 66675
          mmTop = 3969
          mmWidth = 25665
          BandType = 3
          GroupNo = 0
        end
        object ppLabel27: TppLabel
          UserName = 'Label27'
          AutoSize = False
          Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom]
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = True
          Border.Weight = 1.000000000000000000
          Caption = 'Stokkodu'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3969
          mmLeft = 38365
          mmTop = 10054
          mmWidth = 38100
          BandType = 3
          GroupNo = 0
        end
      end
      object ppGroupFooterBand1: TppGroupFooterBand
        mmBottomOffset = 0
        mmHeight = 0
        mmPrintPosition = 0
      end
    end
    object raCodeModule1: TraCodeModule
      ProgramStream = {
        01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060E
        50616C657454706C4F6E43616C630B50726F6772616D54797065070B74745072
        6F63656475726506536F75726365068F70726F6365647572652050616C657454
        706C4F6E43616C63287661722056616C75653A2056617269616E74293B0D0A62
        6567696E0D0A202050616C657454706C2E56616C75653A3D312B2047726F7570
        312E427265616B4E6F203B0D0A202050616C6574546F706C616D2E56616C7565
        3A3D50616C657454706C2E56616C75653B0D0A0D0A0D0A0D0A656E643B0D0A0D
        436F6D706F6E656E744E616D65060850616C657454706C094576656E744E616D
        6506064F6E43616C63074576656E74494402210001060F5472614576656E7448
        616E646C65720B50726F6772616D4E616D65061150616C6574546F706C616D4F
        6E43616C630B50726F6772616D54797065070B747450726F6365647572650653
        6F75726365064570726F6365647572652050616C6574546F706C616D4F6E4361
        6C63287661722056616C75653A2056617269616E74293B0D0A626567696E0D0A
        0D0A0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060B50616C65
        74546F706C616D094576656E744E616D6506064F6E43616C63074576656E7449
        4402210000}
    end
    object ppParameterList1: TppParameterList
    end
  end
  object dsTmp: TDataSource
    DataSet = aqTmp
    Left = 178
    Top = 409
  end
  object aqTmp: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 3000
    Parameters = <>
    Left = 133
    Top = 408
  end
  object aqFaturaExcel: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 300
    Parameters = <
      item
        Name = 'bilisno'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      
        'select f.Bilisno,Tarih,Har_GonderiNo,C.Carikodu,C.FirmaAdi,C.Adr' +
        'es,C.ilce,C.Sehir,C.telefon3,Telefon2,C.ilce+'#39' / '#39'+C.Sehir ilcei' +
        'l,'
      
        'st.Stokkodu,st.Cinsi,Sum(fh.Miktar) Miktar,St.Barkod,st.Desi,st.' +
        'Net,st.Brut,ToplamDesi=Sum(fh.Miktar)*Desi,NetToplam=Sum(fh.Mikt' +
        'ar)*Net,BrutToplam=Sum(fh.Miktar)*Brut'
      'from fatura f'
      'left join fathar fh on (f.bilisno=fh.bilisno)'
      'left join Stok st on (st.Stokkod=fh.Stokkod)'
      'left join cari c on (c.carikod=F.Carikod)'
      'where'
      'f.bilisno=:bilisno'
      'Group By f.Bilisno,Tarih,Har_GonderiNo,'
      
        'C.Carikodu,C.FirmaAdi,C.Adres,C.ilce,C.Sehir,C.telefon3,Telefon2' +
        ','
      'st.Stokkodu,st.Cinsi,St.Barkod,st.Desi,st.Net,st.Brut'
      '')
    Left = 410
    Top = 252
  end
  object dsFaturaExcel: TDataSource
    DataSet = aqFaturaExcel
    Left = 461
    Top = 254
  end
  object adoKargoTan: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from tbl_kargotanim where Aktif=1'
      '')
    Left = 580
    Top = 378
  end
  object SD: TSaveDialog
    DefaultExt = '*.xls'
    FileName = 'UmoDataDosyasi'
    Filter = 'Excel Export|*.xls'
    Left = 579
    Top = 221
  end
  object aqUpsExport: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <
      item
        Name = 'BilisNo'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 2406838
      end>
    SQL.Strings = (
      'SELECT  '
      'Waybill=ub.Barkod,'
      
        'AnaPaketNo=(CASE WHEN F.UPSBARKODIRS=ub.Barkod THEN '#39#39' ELSE UPSB' +
        'ARKODIRS END),'
      
        'AliciAdi=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.FirmaAdi Else C' +
        'S.ACIKLAMA End),'
      
        'AlicAdres=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.Adres Else CS.' +
        'ADRES1+'#39#39'+ADRES2 End),'
      'Aliciilce=isnull(ilce.ilce,ilce2.ilce),'
      'Aliciil=il.icerik2,'
      
        'AliciTel=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.Telefon2 Else C' +
        'S.Tel1 End),'
      'AliciDahili='#39#39',AliciPostaKodu='#39#39','
      
        'AliciYetkili=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.Yetkili Els' +
        'e CS.YETKILI End),'
      
        'AliciEmail=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.Email Else CS' +
        '.EPOSTA End),'
      
        'AliciGsm=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.Telefon3 Else C' +
        'S.Tel2 End),'
      'TahMalBedel='#39#39',MalBedBir='#39#39',MalBedTT='#39#39','
      'Ref=isnull(F.Unityirsaliyeno,UnityFaturano) ,'
      'Irsaliyeno=isnull(F.Unityirsaliyeno,UnityFaturano) ,'
      'UrunAd='#39'Bilgisayar ve Bilgisayar Malz.'#39','
      
        'OdemeSekli=(Case When F.OdemeSekli='#39'P'#214#39' THEN '#39'PP'#39' ELSE '#39'FC'#39' END)' +
        ','
      'ServisTipi=3,'
      
        'PaketTipi=(CASE WHEN 0<(Select Count(*) from fathar where Bilisn' +
        'o=F.Bilisno and Stokkod in (Select stokkod from stok where GrupI' +
        'D=75)) THEN '#39'D'#39
      'ELSE '#39'K'#39' END),'
      'D'#246'k'#252'man='#39'H'#39','
      'Cumartesi='#39'H'#39','
      'Telihbr='#39'H'#39','
      'SigortaBedel='#39#39','
      'TeslimatEmail='#39#39','
      'GeriWaybill='#39#39','
      
        'GonMasrafKodu=isnull(Har_BelgeTuru,F.Tipi+Cast(FaturaTipi AS nva' +
        'rchar(10))),'
      
        'AlcMasrafKodu=isnull(Har_BelgeTuru,F.Tipi+Cast(FaturaTipi AS nva' +
        'rchar(10))),'
      'UcuncuFirmaMasrafKod='#39#39','
      
        'GonYetkili=isnull(Har_BelgeTuru,F.Tipi+Cast(FaturaTipi AS nvarch' +
        'ar(10))),'
      
        'PaketAdedi=(Case isnull(F.Okutmakoli,0) When 0 THEN 1 ELSE F.Oku' +
        'tmakoli END)'
      ',ub.Agirlik,ub.En,ub.Boy,ub.Yukseklik,ub.Hacim'
      'from fatura F  with (nolock) '
      'Join Cari C on (F.CariKod=C.Carikod)'
      'join TblUpsIrsaliyeBarkod ub on (ub.BilisNo=F.BilisNo)'
      
        'Left Join (select ILCEAD=(case when exists(select top 1 id from ' +
        'ilce Where ilid=tbl_sevkiyatadres.SEHIR and ilce=tbl_sevkiyatadr' +
        'es.ILCEAD) then tbl_sevkiyatadres.ILCEAD else '#39'MERKEZ'#39' END),SEHI' +
        'R,KODU,ACIKLAMA,ADRES1,ADRES2,Tel1,Tel2,EPOSTA,YETKILI,UNITYCODE' +
        ' from tbl_sevkiyatadres) CS on (F.SevkiyatKod=CS.UNITYCODE)'
      
        'Left Join il on (il.tur=(Case When ISNULL(CS.Kodu,'#39#39')='#39#39' Then C.' +
        'Sehirkod Else CS.SEHIR End))'
      
        'Left Join ilce on (ilce.ilid=il.tur and ilce.ilce=(Case When (IS' +
        'NULL(CS.Kodu,'#39#39')='#39#39') and (isnull(C.ilce,'#39#39')<>'#39#39') Then C.ilce WHE' +
        'N (ISNULL(CS.Kodu,'#39#39')<>'#39#39') and (isnull(CS.ILCEAD,'#39#39')<>'#39#39') THEN C' +
        'S.ILCEAD Else '#39'MERKEZ'#39' End))'
      
        'Left Join ilce ilce2 on (ilce2.ilid=il.tur and ilce2.ilce='#39'MERKE' +
        'Z'#39')'
      
        'Left Join TBLUPSIlce on (isnull(ilce.Upsid,ilce2.Upsid)=TBLUPSIl' +
        'ce.SiraNo)'
      'where F.bilisno=:BilisNo'
      
        'and Exists(SELECT BilisNo from TblUpsIrsaliyeBarkod Where F.Bili' +
        'sNo=Bilisno and f.UPSBARKODIRS=Barkod)')
    Left = 635
    Top = 218
  end
end
